Page Control Search – Dynamics 365 BC Table Reference

SELECT p.ID ,p.Name ,pc.ControlName ,post.post_name FROM azrcrv_PageControls AS pc INNER JOIN azrcrv_Pages AS p ON p.ID = pc.PageNo INNER JOIN bct_posts AS post ON post.post_title = p.Name WHERE pc.ControlName = 'Transaction Type' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to TRANSACTION TYPE

Seq No	Page Number	Page Name	Control Name
1	40	Item Journal	Transaction Type
2	41	Sales Quote	Transaction Type
3	42	Sales Order	Transaction Type
4	43	Sales Invoice	Transaction Type
5	44	Sales Credit Memo	Transaction Type
6	49	Purchase Quote	Transaction Type
7	50	Purchase Order	Transaction Type
8	51	Purchase Invoice	Transaction Type
9	52	Purchase Credit Memo	Transaction Type
10	201	Job Journal	Transaction Type
11	286	Recurring Item Jnl.	Transaction Type
12	311	Intrastat Journal	Transaction Type
13	507	Blanket Sales Order	Transaction Type
14	509	Blanket Purchase Order	Transaction Type
15	755	Standard Item Journal Subform	Transaction Type
16	4813	Intrastat Report Subform	Transaction Type
17	4816	Intrastat Report Lines	Transaction Type
18	5159	Sales Order Archive	Transaction Type
19	5162	Sales Quote Archive	Transaction Type
20	5164	Purchase Quote Archive	Transaction Type
21	5167	Purchase Order Archive	Transaction Type
22	5740	Transfer Order	Transaction Type
23	5743	Posted Transfer Shipment	Transaction Type
24	5745	Posted Transfer Receipt	Transaction Type
25	5900	Service Order	Transaction Type
26	5933	Service Invoice	Transaction Type
27	5935	Service Credit Memo	Transaction Type
28	5964	Service Quote	Transaction Type
29	6620	Blanket Sales Order Archive	Transaction Type
30	6623	Blanket Purchase Order Archive	Transaction Type
31	6627	Sales Return Order Archive	Transaction Type
32	6630	Sales Return Order	Transaction Type
33	6640	Purchase Return Order	Transaction Type
34	6644	Purchase Return Order Archive	Transaction Type

Dynamics 365 BC Table ReferencePage Control Search